﻿
IF object_id(N'dbo.[UDS_SCOPE]', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_SCOPE] (
        [FileName]         nvarchar(300)  COLLATE Chinese_PRC_CI_AS NULL,
        [Path]             nvarchar(300)  COLLATE Chinese_PRC_CI_AS NULL,
        [Characterization] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
        [Rank]             nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Create]           datetime      NULL,
        [Size]             int           NULL,
        [spid]             int           NULL CONSTRAINT [DF_UDS_SCOPE_spid] default((@@spid))
    );
END
GO
